-- Create the Audit table - note the additional column
CREATE TABLE OldCustomerDemographics_AUDIT
(
	CustomerID INT
	, CustFirstName VARCHAR(50) NOT NULL
	, CustLastName VARCHAR(50) NOT NULL
	, CustSalesRegion VARCHAR(20) NULL
	, CustStatus VARCHAR(20) NOT NULL
	, AUDIT_NewSalesRegion VARCHAR(20) NULL
)